|
|
|
|
|
Excel 2007 Intermediate
|
|
|
|
The Excel 2007 Intermediate tutorial takes you step by step through intermediate spreadsheet tasks as specified in the Microsoft Certified Application Specialist (MCAS) exam (77-602). |
|
|
|
| Working with Existing Spreadsheets |
Modifying Worksheets |
|
Formatting Worksheets |
|
Custom and Conditional Formats |
|
Cell and Table Styles |
| Workspaces and Views |
Saving a Workspace |
|
Excel Views |
|
Using Custom Views |
| Presenting Data Visually |
Illustrations |
|
Outlining |
|
Sorting and Filtering Data |
|
Trendlines |
| Spreadsheet Tools |
Auditing Tools |
|
Scenario Manager |
|
Using Macros |
| Importing, Exporting and Pivot Tables |
Importing, Exporting and Queries |
|
Working with PivotTables |
|
|
|
|
|
© KNOWHOW2 Pty Ltd
|
|
|